Aside

Download a PDF of this CV

Contact

Language Skills

R
SQL
PowerBI
Python
Bash
Azure

Disclaimer

Made with the R package pagedown.

Last updated on 2020-10-19.

Main

Douglas MacDonald

I have a deep love and affinity for all things data and computing. My professional career has always been focused on helping others understand their data, streamline their current processes, and provide value to stakeholders.

Education

M.Phil Quantitative Methods

The University of Pennsylvania

Philadelphia, PA

2020 - 2017

M.S. Experimental Psychology

Saint Joseph’s University

Philadelphia, PA

2014 - 2012

  • Thesis: Emotional Intelligence and Entitlement in the Workplace
  • Member of Sigma Xi Scientific Research Society (prospective member can only apply if nominated by a current member)

B.S. Psychology

Saint Joseph’s University

Philadelphia, PA

2013 - 2009

  • Graduated Cum Laude
  • Dean’s List, Spring 2010 – Spring 2014
  • Presidential Scholarship

Research Experience

Graduate Research Assistant

Saint Joseph’s University

Philadelphia, PA

2014 - 2013

  • Reported to and worked one on one with the Chair of the department. Worked one on one with tenured professors in the Food Marketing Department
  • Conducted independent data collection, coding of data, theory development, survey generation, data analysis, and management of large data sets (exceeding 4 million respondents)
  • Teaching Assistant for several undergraduate level classes. Required to lecture and present new material

Assistant Consultant Support

Applied Psychological Techniques

Darien, CT

2012 - 2011

  • Coded and analyzed data from clients. Literary searches and company profiling. Collaborated with and assisted professionals in the field of Industrial/Organizational Psychology. Worked first hand with Kathleen K. Lundquist, Ph.D, CEO of APTMetrics.
  • Read 10-k reports for company profiles. Greatly improved efficiency in Microsoft Word, Excel, Adobe Acrobat Pro

Industry Experience

I have worked in a variety of roles in data/decision science, in both non-profit and for-profit sectors.

Director for Research and Analytics Development

Middle States Commission on Higher Education

Philadelphia, PA

Current - 2019

Senior Analytics Specialist

Middle States Commission on Higher Education

Philadelphia, PA

2019 - 2017

  • Develop automated data pipelines (extract, transform, and load clean data) leveraging Federally available and proprietary data for use in reports in analyses.
  • Create databases, develop algorithms and statistical models, and perform statistical analyses appropriate to the available data and reporting requirements. Develop dashboards, reports, charts, graphs, and tables displaying the outcomes of analyses for use by internal and external stakeholders.
  • Use system reports and analyses to identify potentially problematic data, make corrections, and determine root cause.

Lead Decision Science Analyst

Communications Media Inc

Philadelphia, PA

2017 - 2016

  • Directly reported to and collaborated with Wayne Obetz, PhD, VP of Investment Analytics and Decision Sciences, on various company and client initiatives. Conducted statistical analyses and modeling (accomplished within R, and KNIME an open source analytics platform), appliedcommon machine learning (i.e. Random-Forest) techniques to better understand behavioral characteristics of physicians (accomplished within R and KNIME)
  • Conducted classification techniques (i.e., CART - Classification and Regression Trees, CHAID, k-means) to produce comprehensive profiles of physicians (accomplished within R and KNIME). Joined and appended new data sets and sources (Prescription information, Sales Rep activity, Sample Request data, etc.) to existing marketing target lists and third party syndicated research (accomplished within R and SPSS). Manipulated, transformed, prepared and staged complex data sets for statistical analyses (extracting key variables of interest, string manipulation, and applied business rules to better define sub-segments of target list) (accomplished within R).
  • Managed large database structures (accomplished within R and SQL). Built comprehensive, client ready dashboards in Tableau (a data visualization and analysis tool). Effectively communicated results and implications to internal teams and external clients. Developed clear next steps from resulting analyses. Developed automated data manipulation and analysis scripts and functions (in R and SPSS). Liaison between IQRx and Product Development team to frame and build/QA databases, identify primary keys between data sources, and test possible resolutions to the department’s data warehousing needs and requirements

Application Developer / Data Analyst II

Development and Alulmni Relations, University of Pennsylvania

Philadelphia, PA

2017 - 2017

  • Deliver system solutions for business needs involving Development and Alumni Relations software systems, data visualization and query tools (accomplished within R; an open source language and environment for statistical computing and graphics, SQL, Qlikview (data visualization and analysis tool), and Business Objects)
  • Design, code, simulate, test, implement and maintain reporting solutions and associated middleware, interfaces and databases in highly complex solutions (accomplished within SQL, R, and Python). Develop predictive models, composed of various complex data sources, to identify those individuals likely to make a large contribution to the University, new donors, and donor retention (accomplished within R [data transformation, modeling] SQL [data cleansing, aggregation]). Develop high level summary reporting dashboards for internal and external use (accomplished within R (Markdown), and Qlikview)
  • Analyze functional requirements and advise users in the planning, selection, implementation and use of solutions to address business requirements. Advise the planning, implementation, measurement, and analysis of success of giving campaigns. Ensure adherence to technical, quality assurance, data integrity, and security standards. Plan, organize, and manage projects and associated schedules and budgets.

Campaign Analyst

Communications Media Inc

Philadelphia, PA

2015 - 2014

  • Lead analyst for all Business Intelligence efforts for IQRx (Analytics Department). Provided statistical analysis and modeling of doctor behavioral data and the resulting growth in script writing behavior (data was cleaned, manipulated, joined and analyzed within R). Built-out reporting dashboards (visualized in Tableau) and was responsible for organizing and scheduling all data.
  • Responsible for the campaign management, reporting/insights, analysis and data-feed for 31 brands across five clients spanning different therapeutic markets and conditions. Company Trainer for Tableau and Tableau Doctor (internal Tableau troubleshooting team). Utilize behavioral data from our proprietary doctor list to plan, track, and validate our media efforts.
  • Spear-headed statistical analyses for custom engaged user segments to validate marketing techniques. Developed and provided insights, analysis, and reporting for all assigned clients. Partnered with VP of Product Development to automate cost-actualization processes that were provided as a data-feed for external clients. As well as data-transformation for individual level data received from publishers (processes automated using Java).




Teaching Experience

I am passionate about education. I believe that no topic is too complex if the teacher is empathetic and willing to think about new methods of approaching task.

Javascript for Shiny Users

RStudio::conf 2020

N/A

2020

Data Visualization Best Practices

DataCamp

N/A

2019 - 2019

  • Designed from bottom up course to teach best practices for scientific visualizations.
  • Uses R and ggplot2.
  • In top 10% on platform by popularity.

Improving your visualization in Python

DataCamp

N/A

2019 - 2019

  • Designed from bottom up course to teach advanced methods for enhancing visualization.
  • Uses python, matplotlib, and seaborn.

Advanced Statistical Learning and Inference

Vanderbilt Biostatistics Department

Nashville, TN

2018 - 2017

  • TA and lectured
  • Topics covered from penalized regression to boosted trees and neural networks
  • Highest level course offered in department

Advanced Statistical Computing

Vanderbilt Biostatistics Department

Nashville, TN

2018 - 2018

  • TA and lectured
  • Covered modern statistical computing algorithms
  • 4th year PhD level class

Statistical Computing in R

Vanderbilt Biostatistics Department

Nashville, TN

2017 - 2017

  • TA and lectured
  • Covered introduction to R language for statistics applications
  • Graduate level class